﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'usp_UPDMS_CFG_SETTING_MGT_Get_Setting_Value_By_User_Id')
	BEGIN
		DROP Procedure usp_UPDMS_CFG_SETTING_MGT_Get_Setting_Value_By_User_Id
	END
GO

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO
/******************************************************************************
**	Name : usp_UPDMS_CFG_SETTING_MGT_Get_Setting_Value_By_User_Id
**	Desc : 사용자별 설정값 조회
**	Test Exec Query : Exec usp_UPDMS_CFG_SETTING_MGT_Get_Setting_Value_By_User_Id 'smstyle'
**	Called by : Global.cs
**	Program ID : AnyWhere
**	Auth : 송시명
**	Date : 2013-05-07
*******************************************************************************
**	Change History
*******************************************************************************
**	Date:		Author:		Description:
**	--------	--------	---------------------------------------
**	
*******************************************************************************/
CREATE PROC [dbo].[usp_UPDMS_CFG_SETTING_MGT_Get_Setting_Value_By_User_Id]
@ls_user_id nvarchar(20)
AS
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
SET NOCOUNT ON

SELECT Setting_Cd,
       ISNULL(Setting_Value, '') AS Setting_Value
  FROM UPDMS_CFG_SETTING_MGT WITH(NOLOCK)
 WHERE Use_Yn = 'Y'

GO